Requirement already satisfied: sklearn in ./venv/lib/python3.10/site-packages (0.0.post1)

[notice] A new release of pip available: 22.2.2 -> 23.0.1
[notice] To update, run: pip install --upgrade pip
Requirement already satisfied: squarify in ./venv/lib/python3.10/site-packages (0.4.3)

[notice] A new release of pip available: 22.2.2 -> 23.0.1
[notice] To update, run: pip install --upgrade pip
/home/ayush/Documents/Project/ayush/customer_segm_RFM
Out[5]:
Unnamed: 0 InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerID Country len
0 0 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 6 2010-12-01 08:26:00 2.55 17850.0 United Kingdom 34
1 1 536365 71053 WHITE METAL LANTERN 6 2010-12-01 08:26:00 3.39 17850.0 United Kingdom 19
2 2 536365 84406B CREAM CUPID HEARTS COAT HANGER 8 2010-12-01 08:26:00 2.75 17850.0 United Kingdom 30
3 3 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 6 2010-12-01 08:26:00 3.39 17850.0 United Kingdom 35
4 4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 6 2010-12-01 08:26:00 3.39 17850.0 United Kingdom 30
... ... ... ... ... ... ... ... ... ... ...
244420 245898 558637 22032 BOTANICAL LILY GREETING CARD 12 2011-06-30 20:07:00 0.42 17891.0 United Kingdom 28
244421 245899 558637 22028 PENNY FARTHING BIRTHDAY CARD 12 2011-06-30 20:07:00 0.42 17891.0 United Kingdom 28
244422 245900 558637 22033 BOTANICAL ROSE GREETING CARD 12 2011-06-30 20:07:00 0.42 17891.0 United Kingdom 28
244423 245901 558637 22029 SPACEBOY BIRTHDAY CARD 12 2011-06-30 20:07:00 0.42 17891.0 United Kingdom 22
244424 245902 558637 22024 RAINY LADIES BIRTHDAY CARD 12 2011-06-30 20:07:00 0.42 17891.0 United Kingdom 26

244425 rows × 10 columns

Out[7]:
Timestamp('2011-06-30 20:07:00')
Out[8]:
Unnamed: 0              int64
InvoiceNo              object
StockCode              object
Description            object
Quantity                int64
InvoiceDate    datetime64[ns]
UnitPrice             float64
CustomerID            float64
Country                object
len                     int64
dtype: object
2011-12-10 00:00:00
Out[11]:
Unnamed: 0 InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerID Country len TotalSum Frequency
0 0 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 6 2010-12-01 08:26:00 2.55 17850.0 United Kingdom 34 15.30 373 days 15:34:00
1 1 536365 71053 WHITE METAL LANTERN 6 2010-12-01 08:26:00 3.39 17850.0 United Kingdom 19 20.34 373 days 15:34:00
2 2 536365 84406B CREAM CUPID HEARTS COAT HANGER 8 2010-12-01 08:26:00 2.75 17850.0 United Kingdom 30 22.00 373 days 15:34:00
3 3 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 6 2010-12-01 08:26:00 3.39 17850.0 United Kingdom 35 20.34 373 days 15:34:00
4 4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 6 2010-12-01 08:26:00 3.39 17850.0 United Kingdom 30 20.34 373 days 15:34:00
... ... ... ... ... ... ... ... ... ... ... ... ...
244420 245898 558637 22032 BOTANICAL LILY GREETING CARD 12 2011-06-30 20:07:00 0.42 17891.0 United Kingdom 28 5.04 162 days 03:53:00
244421 245899 558637 22028 PENNY FARTHING BIRTHDAY CARD 12 2011-06-30 20:07:00 0.42 17891.0 United Kingdom 28 5.04 162 days 03:53:00
244422 245900 558637 22033 BOTANICAL ROSE GREETING CARD 12 2011-06-30 20:07:00 0.42 17891.0 United Kingdom 28 5.04 162 days 03:53:00
244423 245901 558637 22029 SPACEBOY BIRTHDAY CARD 12 2011-06-30 20:07:00 0.42 17891.0 United Kingdom 22 5.04 162 days 03:53:00
244424 245902 558637 22024 RAINY LADIES BIRTHDAY CARD 12 2011-06-30 20:07:00 0.42 17891.0 United Kingdom 26 5.04 162 days 03:53:00

244425 rows × 12 columns

Recency¶

Reference Date: 2011-12-10 00:00:00
Out[12]:
count mean std min 25% 50% 75% max
CustomerID 3002.0 15300.995670 1720.020920 12346.0 13817.5 15263.5 16779.75 18287.0
recency 3002.0 232.783145 60.930992 162.0 183.0 213.0 271.00 373.0
Out[13]:
CustomerID recency
0 12346.0 325.0
1 12347.0 183.0
2 12348.0 248.0
3 12350.0 310.0
4 12352.0 262.0
... ... ...
2997 18277.0 318.0
2998 18280.0 277.0
2999 18281.0 180.0
3000 18283.0 169.0
3001 18287.0 201.0

3002 rows × 2 columns

Frequency¶

Monetary Value¶

Out[17]:
CustomerID recency frequency TotalSum
0 12346.0 325.0 2 0.00
1 12347.0 183.0 4 2205.95
2 12348.0 248.0 3 1487.24
3 12350.0 310.0 1 334.40
4 12352.0 262.0 8 601.18
... ... ... ... ...
2997 18277.0 318.0 1 -12.75
2998 18280.0 277.0 1 180.60
2999 18281.0 180.0 1 80.82
3000 18283.0 169.0 7 842.58
3001 18287.0 201.0 1 765.28

3002 rows × 4 columns

Out[19]:
CustomerID    0
Recency       0
Frequency     0
Monetary      0
dtype: int64
Out[21]:
CustomerID Recency Frequency Monetary
0 12346.0 325.0 2 0.00
1 12347.0 183.0 4 2205.95
2 12348.0 248.0 3 1487.24
3 12350.0 310.0 1 334.40
4 12352.0 262.0 8 601.18
... ... ... ... ...
2997 18277.0 318.0 1 -12.75
2998 18280.0 277.0 1 180.60
2999 18281.0 180.0 1 80.82
3000 18283.0 169.0 7 842.58
3001 18287.0 201.0 1 765.28

3002 rows × 4 columns

Out[22]:
CustomerID Recency Frequency Monetary R F M
0 12346.0 325.0 2 0.00 1 2 1
1 12347.0 183.0 4 2205.95 4 3 4
2 12348.0 248.0 3 1487.24 2 3 4
3 12350.0 310.0 1 334.40 1 1 2
4 12352.0 262.0 8 601.18 2 4 3
Out[23]:
CustomerID Recency Frequency Monetary R F M RFM_Segment_Concat
0 12346.0 325.0 2 0.00 1 2 1 1.02.01.0
1 12347.0 183.0 4 2205.95 4 3 4 4.03.04.0
2 12348.0 248.0 3 1487.24 2 3 4 2.03.04.0
3 12350.0 310.0 1 334.40 1 1 2 1.01.02.0
4 12352.0 262.0 8 601.18 2 4 3 2.04.03.0
64
0     4
1    11
2     9
3     4
4     9
Name: RFM_Score, dtype: int64
Out[25]:
CustomerID Recency Frequency Monetary R F M RFM_Segment_Concat RFM_Score RFM_Level
0 12346.0 325.0 2 0.00 1 2 1 1.02.01.0 4 Requires Attention
1 12347.0 183.0 4 2205.95 4 3 4 4.03.04.0 11 Can't Loose Them
2 12348.0 248.0 3 1487.24 2 3 4 2.03.04.0 9 Can't Loose Them
3 12350.0 310.0 1 334.40 1 1 2 1.01.02.0 4 Requires Attention
4 12352.0 262.0 8 601.18 2 4 3 2.04.03.0 9 Can't Loose Them
5 12353.0 204.0 1 89.00 3 1 1 3.01.01.0 5 Promising
6 12354.0 232.0 1 1079.40 2 1 3 2.01.03.0 6 Potential
7 12355.0 214.0 1 459.40 2 1 2 2.01.02.0 5 Promising
8 12356.0 245.0 2 2753.08 2 2 4 2.02.04.0 8 Champions
9 12359.0 189.0 4 3459.93 3 3 4 3.03.04.0 10 Can't Loose Them
10 12360.0 200.0 1 1083.58 3 1 3 3.01.03.0 7 Loyal/Commited
11 12361.0 287.0 1 189.90 1 1 1 1.01.01.0 3 Demands Activation
12 12362.0 225.0 3 969.44 2 3 3 2.03.03.0 8 Champions
13 12363.0 242.0 1 299.10 2 1 2 2.01.02.0 5 Promising
14 12365.0 291.0 3 320.69 1 3 2 1.03.02.0 6 Potential
                   Recency Frequency Monetary      
                      mean      mean     mean count
RFM_Level                                          
Can't Loose Them     187.3       6.8   2642.2  1150
Champions            217.3       2.4    713.5   306
Demands Activation   329.4       1.0    113.2   189
Loyal/Commited       226.4       1.9    486.9   305
Potential            244.5       1.5    387.0   369
Promising            269.2       1.2    273.1   347
Requires Attention   303.7       1.1    190.8   336